trace table

how to: derive a template from a trace file or trace table (sql server profiler)

如何从跟踪文件或跟踪表派生模板（SQLServerProfiler）

select the set maximum rows check box, and specify a maximum number of rows for the trace table.

选中“设置最大行数”复选框，然后指定跟踪表的最大行数。

The trace-driven simulations demonstrate that MTH has a better performance than the original hash table algorithm, which suits the high-speed state inspection firewall well.

历史流量驱动的性能仿真实验表明，MTH算法的性能明显优于原哈希表算法，能够满足高速状态检测防火墙的速度要求。

make sure that tracing has stopped before using a trace table as a workload.

确保在将跟踪表用作工作负荷之前已经停止了跟踪。

database engine tuning advisor does not support using a trace table to which trace events are still being written as a workload.

数据库引擎优化顾问不支持将还在写入跟踪事件的跟踪表作为工作负荷使用。

you analyze the trace data in the sql trace table after your load test has completed.

在完成负载测试之后，可以在“SQL跟踪”表中分析跟踪数据。

when using a trace table as a workload, that table must exist on the same server where database engine tuning advisor is tuning.

使用跟踪表作为工作负荷时，该表必须位于数据库引擎优化顾问正在优化的那台服务器上。

in the connect to server dialog box, connect to the sql server database that will contain the trace table.

在“连接到服务器”对话框中，连接到将包含跟踪表的SQLServer数据库。

the following code example specifies the mydatabase. mydbowner. tuningtable001 trace table for the workload element.

下列代码示例指定Workload元素的MyDatabase.MyDBOwner.TuningTable001跟踪表。

to set a maximum table size for a trace table

设置跟踪表的最大表大小

make sure that tracing has stopped before using a trace table as a workload for database engine tuning advisor.

在使用跟踪表作为数据库引擎优化顾问的工作负荷之前，确保跟踪已停止。